<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License

Name       : Beach Sunset
Description: A two-column, fixed-width design for 1024x768 screen resolutions.
Version    : 1.0
Released   : 20090416

-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>ModificarModelo</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
<!--
.Estilo1 {font-size: 36px ; color: #FFFFFF}
.Estilo2 {font-size: 14px}
.Estilo3 {color: #FFFFFF}
.Estilo4 {font-size: 36px}
-->
</style>
</head>
<body>
<div id="wrapper">

	<div id="header">	
 <br<div id="header">	
 <br />
		<div id="menu">				      
				<li  class="active"><a href="HOME.php" title="HOME">HOME</a></li>
				<li><a href="INSERTAR.php" title="INSERTA">INSERTAR</a></li>
				<li><a href="ELIMINAR.php" title="ELIMINAR">ELIMINAR</a></li>
				<li><a href="CONSULTAR.php" title="CONSULTAR">CONSULTAR</a></li>
				<li><a href="MODIFICAR.php" title="MODIFICAR">MODIFICAR</a></li>				
	  	</div>  <!-- end #menu -->	
						
		<div id="search">
			<div id="menu">						
					<li><a href="MOSTRAR.php" title="MOSTRAR">MOSTRAR</a></li>
			</div> <!-- end #menu -->	
		</div>		<!-- end #search -->	
  </div>    <!-- end #header -->	
	
	
	<div class="title Estilo1" id="logo">
			  <h2 class="title Estilo1">&nbsp;</h2>
			  <h2 class="title Estilo1">&nbsp;</h2>
			  <h2 class="title Estilo1">&nbsp;</h2>
			  <h2 class="title Estilo1">&nbsp;</h2>
			  <h2 class="title Estilo1">	Take a Rest... </h2>
		    <div align="left"></div>
  </div> 	<!-- end #logo -->  
	
</div> <!-- end *header- wrapper -->

<span class="Estilo2"></span>
	
		<hr />
		<div id="page">



      <table width="99%" border="0" cellspacing="0" cellpadding="0">
        <tr bgcolor="#FE9230">
		  <td width="9%"><div align="center"><font color="#FFFFFF"><strong><font size="2" face="Arial, Helvetica, sans-serif">ID</font></strong></font></div></td>
          <td width="39%"><div align="center"><font color="#FFFFFF"><strong><font size="2" face="Arial, Helvetica, sans-serif">NOMBRE</font></strong></font></div></td>
          <td width="39%" bgcolor="#FE9230"><div align="center"><font color="#FFFFFF"><strong><font size="2" face="Arial, Helvetica, sans-serif">DESCRIPCION</font></strong></font></div></td>   
		  <td><div align="center"></a></div></td>
        </tr>
									<?php 
						$db2="(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST=localhost)(PORT=1521)) (CONNECT_DATA = (SID = xe)))";
						$con2 = OCILogon ('SPA','1234',$db2) or die( "No se pudo Conectar a la base de Datos!") or die (ocierror());  //Establece una conexión 						  																																			 con Oracle
						
						$query = "SELECT * FROM MODELO ORDER BY PK_ID_MODELO ASC";
						$sentencia = OCIParse($con2,$query); 
						OCIExecute($sentencia, OCI_DEFAULT);						
						$rows = OCIFetchStatement($sentencia,$results);
						$keys = array_keys($results); 						
						OCICommit($con2); 
						OCILogOff($con2); // Termina la conexion con Oracle
						
						?>
						
        <?php 
    $cont = 0;
    while ($cont < $rows) {
  	$id_p = $results["PK_ID_MODELO"][$cont];
	$nombre = $results["NOMBRE_MODELO"][$cont];
	$descripcion = $results["DESCRIPCION"][$cont];
	
  ?>
        <tr>
		<td><div align="center">&nbsp;<font size="2" face="Arial, Helvetica, sans-serif"><?php echo $id_p ?></div></td>		
		<td><div align="center">&nbsp;<font size="2" face="Arial, Helvetica, sans-serif"><a href="ModificarModeloDatos.php?id_p=<?php echo $id_p; ?>"><?php echo $nombre ?></a></font><span class="Estilo1">&nbsp;</span></div></td>
		<td><div align="center" class="Estilo3">&nbsp;<font size="2" face="Arial, Helvetica, sans-serif"><?php echo $descripcion ?></font><span class="Estilo4">&nbsp;</span></div></td>				  
					  

        </tr>
        <?php	$cont++; } ?>
      </table>
	  <p><br />
		</p>
	  <p>&nbsp; </p>
	  <div align="center">
	    <a href="InsertarModelo.php">Insertar Modelo </a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="EliminarModelo.php">Eliminar Modelo </a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="MostrarModelo.php">Mostrar Modelo </a>

	  <p>&nbsp; </p>
</div>  <!-- end #page -->

		<div id="footer">
			<p> Design by <a href="http://www.freecsstemplates.org/">Nubielis, Eduardo, Daniel </a></p>
		</div>  <!-- end #footer -->

</div>
</body>
</html>